package com.huyaanalysisplatform.mapper;

import com.huyaanalysisplatform.entity.TUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Huadi Group 12
 * @since 2021-08-01
 */
@Mapper
public interface TUserMapper extends BaseMapper<TUser> {

    @Select({"<script>select * from t_user where name = #{name} </script>"})
    TUser selectByName(@Param("name") String name);

    @Select({"<script>select * from t_user where phone = #{phone}</script>"})
    TUser selectByPhone(@Param("phone") String phone);

    @Select("<script>select * from t_user where email = #{email} </script>")
    TUser selectByEmail(@Param("email") String email);

}
